Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
42 1Z0-072 When is a SID_LIST_>listener name< section required in a LISTENER.ORA file? when the listener uses multiple port numbers for different database instances when a static listener is used when a dynamic listener is used when multiple dynamic listeners are used when the list of existing database services must be defined 2 SC edit delete
41 1Z0-072 Which is always true about privileges? Connections as SYSTEM can use only the SYSOPER privilege. Connections as SYS must be made using the SYSDBA privilege System privileges can be granted only to users. The owner of a schema is granted all object privileges within the schema by default. The SYSDBA privilege can be granted to a user or role. 4 SC edit delete
40 1Z0-072 Which is true about the UNLIMITED TABLESPACE SYSTEM privilege? It can be granted to any user and any role. It is overridden by any specified user space quota. It allows a user to have unlimited space in any tablespace in the database. It allows a user to have unlimited space only in his or her default permanent tablespace. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist. 3 SC edit delete
39 1Z0-072 You execute this command to connect to an instance from a client on a different machine: 39-quedba.png It must contain the address protocol for only one listener. It must contain only one address protocol for one listener It must be defined in the tnsnames.ora file on the client side. It must be defined in the tnsnames.ora file on the server side. It must have the same name as the SERVICE_NAME defined in it. 4,5 SC edit delete
38 1Z0-072 In your database, you want to create a tablespace of non-standard block size 38-quedba.png All other DB_nK_CACHE_SIZE parameters should be set to zero. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA. The value of the DB_CACHE_SIZE parameter should not be 16 KB. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB. 2 SC edit delete
37 1Z0-072 Which two are true about undo tablespaces? (Choose two.) They can be recovered only when an instance is in MOUNT state. They are always owned by SYS. They must have only one data file. There can be multiple active undo tablespaces for a single instance database. SYSDBA users can create objects in them. 3, 4 MC edit delete
36 1Z0-072 EMP_IDX is an index on the EMP.ENO column. 36-quedba.png Drop and re-create EMP_IDX. Coalesce EMP_IDX. Shrink EMP. Rebuild EMP_IDX online in a tablespace with sufficient space. Shrink TBS1. 1,2 MC edit delete
35 1Z0-072 You execute this command: Which two statements are true about the SALES tablespace? (Choose two.) The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation. It is read-only by default. DML operations performed on objects in this tablespace are not logged by default. It uses the default blocksize used at database creation It is a locally managed tablespace. It is offline by default. 1, 4 MC edit delete
34 1Z0-072 For which three purposes is UNDO used? (Choose three.) flashback queries FLASHBACK TABLE TO BEFORE DROP operations the roll forward phase of instance recovery RESTORE DATABASE operations ROLLBACK operations read consistency 1, 5, 6 MC edit delete
33 1Z0-072 In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE. UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on. Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction’s first update? It succeeds and the generated undo is stored in SYSAUX. It succeeds and the generated undo is stored in TEMP. It fails and returns the error message “Snapshot too old”. It succeeds and the generated undo is stored in SYSTEM. It fails and returns the error message “ORA=30036”: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’”. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo. 6 SC edit delete
32 1Z0-072 Which two are true about the AL32UTF8 character set? (Choose two.) It is used to encode data for columns of any data type. It supports multilingual databases. It uses less space than other character sets, for all data types It is used to store PL/SQL source code It improves the I/O performance of a database compared to other character sets. 2, 3 MC edit delete
31 1Z0-072 Which is true about revoking roles? Only users who are granted the DBA role can revoke a role. Only users who are granted SYSDBA can revoke a role. Users who have the GRANT ANY ROLE privilege can revoke any role. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role. Users can revoke a role that is granted to them through other roles. 4 SC edit delete
30 1Z0-072 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. 30-quedba.png as SCOTT in BOSTON_DB as SYS in both the databases as SCOTT in BOSTON_DB and SYS in DALLAS_DB as SCOTT in both the databases as SCOTT in DALLAS_DB 4 SC edit delete
29 1Z0-072 Which two tasks can you perform by using DBCA for a new database? Register it with an available Enterprise Manager Management server. Configure a nonstandard block size. Configure incremental backups. Enable flashback. Create user tablespaces. 1, 5 MC edit delete
28 1Z0-072 Which two are segment types? (Choose two.) table partition materialized views on a prebuilt container stored procedure sequence table view 1, 5 MC edit delete
27 1Z0-072 Which two tasks can be performed in the NOMOUNT state? (Choose two.) re-creating control files full database recovery enabling online redo log archiving renaming data files creating a database 1, 5 MC edit delete
26 1Z0-072 Which two are true about complete and incomplete recovery? (Choose two.) Uncommitted transactions will be rolled back after complete recovery completes. The database must have FLASHBACK enabled in order to perform incomplete recovery. Uncommitted transactions will be rolled back after incomplete recovery completes. Incomplete recovery is possible only when the database is open. Only incremental backups can be used to roll forward the database while performing complete recovery. 1, 5 MC edit delete
25 1Z0-072 Which two are true about Oracle recovery and data protection solutions? (Choose two.) RMAN can be used to FLASHBACK a database. RMAN can be used to roll back committed transactions Data Recovery Advisor can be used to restore a single file from an RMAN backupset. Data Recovery Advisor can be used to validate backup strategies. Oracle Data Guard can prevent data loss caused by a site failure. 1, 5 MC edit delete
24 1Z0-072 Which two are true about conventional path SQL load? (Choose two.) It does not generate UNDO. It cannot load data into clustered tables It locks objects being processed. It enforces referential integrity constraints. It always generates redo 1,4 SC edit delete
23 1Z0-072 Which three are true about the Oracle Optimizer? (Choose three.) It determines the optimal table join order and method. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary. It can optimize only SELECT statements. It will only generate SQL Plan Directives specific to a given SQL statement. It can re-optimize execution plans after previous executions detect suboptimal plans. It updates stale object statistics in the Data Dictionary. 1, 2, 3 MC edit delete
22 1Z0-072 Which two are true about the roles? (Choose two.) All privileges and roles granted to a user are enabled by default when the user logs in. The SET ROLE statement can be used once per session. The SET ROLE statement enables as well as disables roles in a session. A role must be disabled before it can be revoked from a user. The ALTER USER statement must be used to set specific default roles for a user. 1, 3 MC edit delete
21 1Z0-072 In a database, the default temporary tablespace is TEMP and USER1’s default tablespace is DATA. 21-quedba.png DATA SYSTEM SYSAUX TEMP UNDOTBS1 4 SC edit delete
20 1Z0-072 Which three object types support deferred segment creation? (Choose three.) partitioned tables external tables heap organized tables clustered tables index organized tables temporary tables 1, 3, 5 MC edit delete
19 1Z0-072 Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.) Third-party tools can be used with database instances in the cloud. Oracle-supplied tools can be used with database instances in the cloud. Database instances in the cloud can be accessed only by using SSH. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created. Database instances in the cloud can be accessed only by using Oracle*Net. 2, 3 MC edit delete
18 1Z0-072 Which two statements are true about Oracle Data Pump? (Choose two.) expdp and impdp are its client components. impdp always uses conventional path inserts when importing data. The DBMS_DATAPUMP package can be used only with Data Pump clients It cannot be used to export data as of a previous SCN. impdp can change target data file names, schemas, and tablespaces during import. 1, 3 MC edit delete
17 1Z0-072 Which two tasks does DBUA perform by default? (Choose two.) setting user tablespaces to “read only” before starting the upgrade adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade running the Pre-Upgrade information tool starting the source database instance if not started enabling flashback in the source database if not enabled 1, 3 MC edit delete
16 1Z0-072 Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.) It applies only to tablespaces with uniform extent size. It overrides the DEFAULT STORAGE clause specified for a tablespace. It specifies whether used and free extents are tracked using free lists or bitmaps. It specifies whether users have direct control over space allocation for the objects in a tablespace. It applies only to permanent tablespaces. It applies only to smallfile tablespaces. 3, 4 MC edit delete
15 1Z0-072 Which three failures do not require intervention for recovery? (Choose three.) user process failure media failure statement failure network interface card (NIC) failure transaction failure 1, 3, 5 MC edit delete
14 1Z0-072 Which two functions are performed by a listener? creating a user session in the System Global Area (SGA) verifying the service name in an incoming user request verifying a user’s authentication credentials maintaining the connection to a client’s user process until the user request is completed returning the results of processing from the server process to the user process connecting a user process to a server process 5, 6 MC edit delete
13 1Z0-072 Which two are true about complete recovery? (Choose two.) The database must have FLASHBACK enabled in order to perform it. It is possible only when the database is in MOUNT state Uncommitted transactions will be rolled back after it completes. Incremental backups can be used to roll forward the database while performing it. Only RMAN backupsets can be used to restore a database as part of it. 1, 2 MC edit delete
12 1Z0-072 What two are benefits of Data Pump? (Choose two.) It can execute in parallel. It can restart failed export jobs It makes use of client system resources. It can export data into sequential media, such as tapes. It represents database metadata information as DDL statements in the dump file. 1, 2 MC edit delete
11 1Z0-072 A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete. You want to verify this. Which two views may reveal for what the user’s session is currently waiting? (Choose two.) V$SYSTEM_EVENT V$SESSION_EVENT V$SESSION_WAIT_CLASS V$SESSION_WAIT V$SESSION 2, 4 MC edit delete
10 1Z0-072 Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users? using Automatic SGA Memory Management (ASMM) setting the LARGE_POOL_SIZE parameter to a non-zero value increasing the size of the PGA setting the SHARED_POOL_SIZE parameter to a non-zero value increasing the number of dispatchers 2, 3, 4 MC edit delete
9 1Z0-072 Which is true about roles? A role can be granted to other roles. Roles can be created only by SYS or SYSTEM. Roles containing object privileges can be created only by the object owner. All roles belong to the SYSTEM schema. A role can be password-protected only if it has been granted system privileges. 5 SC edit delete
8 1Z0-072 orcl.dmp contains a full export of the ORCL database. 08-quedba.png It skips only tables that exist in both ORCL:SH and TESTDB:HR. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR. It skips all indexes of ORCL:SH and ORCL:OE. It skips only indexes that exist in both ORCL:SH and TESTDB:HR. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR. 4,5 MC edit delete
7 1Z0-072 Which two can you use to recover a dropped table? (Choose two.) FLASHBACK QUERY FLASHBACK DATABASE FLASHBACK TRANSACTION FLASHBACK TABLE TO SCN FLASHBACK DROP 4, 5 MC edit delete
6 1Z0-072 What three are true about Oracle Flashback technology? (Choose three.) FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction. FLASHBACK TABLE can be used to rewind a table back in time. FLASHBACK DATABASE can be used to rewind a database back and forth in time. FLASHBACK TABLE can be used to undo dropping a column from a table FLASHBACK QUERY can be used to view committed data at any given point in time 1, 3, 4 MC edit delete
5 1Z0-072 Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.) AWR snapshots must be deleted when no longer required by ADDM. ADDM can recommend shrinking the buffer cache. By default, MMON creates an AWR snapshot every 30 minutes. ADDM can recommend extending the buffer cache. By default, AWR snapshots are automatically purged after eight days. ADDM performs its analysis only whenever a DBA requests it. 2, 5, 6 MC edit delete
4 1Z0-072 Which statement is true about smallfile tablespaces? Extent location metadata is stored in the data dictionary by default. The number of data files is constrained only by the size of the storage array Maximum file size can be set to unlimited only if the logical volume manager supports striping. Segments can span multiple tablespaces. Segments can span multiple data files. 5 SC edit delete
3 1Z0-072 DATADIR1 and DATADIR2 are database directory objects. 03-quedba.png It creates a dump file for the entire database It fails if the total size of the dump file is more than 2 GB. It creates a dump file only for objects in the SYSTEM schema. It creates a master table to store details of the export operation It starts only when four worker processes are available 1,5 SC edit delete
2 1Z0-072 Which three types of files are created by expdp operations? (Choose three.) SQL files dump files reject files log files input data file bad files control files 1, 2, 4 MC edit delete
1 1Z0-072 TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). 01-quedba.png The INCLUDING CONTENTS AND DATAFILES clause must be added to the command. TBS1 must be placed in READ ONLY state. Objects in TBS1 must not be in use when the command is executed. TBS1 must not contain any temp files. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group. 1 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018